metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax_clade = "Bacteria candidate phyla"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_genus	tax_species
2965215	2965215	PRJNA404067_P_NODE_19103_length_240_cov_0.882682_g18716_i0	PRJNA404067	19103	240	0.882682	2.1184368	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	416	6.649999999999998e-112	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g18716	i0	97.917	1	240	5	100	0	1	240	6486	6247	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	240	416	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
2965519	2965519	PRJNA404067_P_NODE_36683_length_203_cov_0.901408_g36296_i0	PRJNA404067	36683	203	0.901408	1.82985824	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	342	9.369999999999999e-90	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g36296	i0	97.044	1	203	6	100	0	1	203	339379	339581	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	203	342	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
4241483	4241483	PRJNA404067_P_NODE_12344_length_299_cov_3.189076_g11958_i0	PRJNA404067	12344	299	3.189076	9.53533724	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	547	2.9099999999999987e-151	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g11958	i0	99.666	1	299	1	100	0	1	299	750554	750852	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	299	547	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
4241621	4241621	PRJNA404067_P_NODE_22184_length_230_cov_2.171598_g21797_i0	PRJNA404067	22184	230	2.171598	4.9946754	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g21797	i0	100	1	230	0	100	0	1	230	324490	324261	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	230	425	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
4241874	4241874	PRJNA404067_P_NODE_37004_length_202_cov_4.276596_g36617_i0	PRJNA404067	37004	202	4.276596	8.63872392	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	363	7.149999999999999e-96	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g36617	i0	99.01	25.4108910891089	202	2	100	0	1	202	973129	972928	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	5133	363	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
6792606	6792606	PRJNA404067_P_NODE_45126_length_167_cov_2.594340_g44739_i0	PRJNA404067	45126	167	2.59434	4.3325478	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	198	1.7e-46	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g44739	i0	97.436	1.02395209580838	117	2	95	1	44	159	777553	777669	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	171	198	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
8068222	8068222	PRJNA404067_P_NODE_8647_length_380_cov_3.561129_g8264_i0	PRJNA404067	8647	380	3.561129	13.5322902	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	652	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g8264	i0	97.878	0.992105263157895	377	8	99	0	4	380	988216	988592	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	377	652	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
9342585	9342585	PRJNA404067_P_NODE_13848_length_280_cov_2.287671_g13461_i0	PRJNA404067	13848	280	2.287671	6.4054788	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g13461	i0	99.643	1	280	1	100	0	1	280	129697	129418	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	280	512	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
9342822	9342822	PRJNA404067_P_NODE_30408_length_210_cov_2.751678_g30021_i0	PRJNA404067	30408	210	2.751678	5.7785238	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	372	1.25e-98	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g30021	i0	98.571	1	210	3	100	0	1	210	68297	68506	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	210	372	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
10618329	10618329	PRJNA404067_P_NODE_12789_length_293_cov_2.698276_g12402_i0	PRJNA404067	12789	293	2.698276	7.90594868	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	516	8.02e-142	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g12402	i0	98.63	0.996587030716723	292	3	99	1	2	292	433717	433426	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	292	516	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
11893699	11893699	PRJNA404067_P_NODE_43950_length_174_cov_4.168142_g43563_i0	PRJNA404067	43950	174	4.168142	7.25256708	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g43563	i0	100	1	174	0	100	0	1	174	322278	322451	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	174	322	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
14443409	14443409	PRJNA404067_P_NODE_18172_length_244_cov_2.715847_g17785_i0	PRJNA404067	18172	244	2.715847	6.62666668	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	427	3.13e-115	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g17785	i0	98.361	1	244	3	100	1	1	244	1029061	1028819	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	244	427	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
14443570	14443570	PRJNA404067_P_NODE_28392_length_215_cov_0.883117_g28005_i0	PRJNA404067	28392	215	0.883117	1.89870155	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g28005	i0	98.14	1	215	4	100	0	1	215	366889	366675	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	215	375	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
15717108	15717108	PRJNA404067_P_NODE_14433_length_273_cov_4.424528_g14046_i0	PRJNA404067	14433	273	4.424528	12.07896144	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	466	7.55e-127	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g14046	i0	97.436	1	273	7	100	0	1	273	1071691	1071963	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	273	466	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
18266516	18266516	PRJNA404067_P_NODE_7495_length_427_cov_1.057377_g7117_i0	PRJNA404067	7495	427	1.057377	4.51499979	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	745	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g7117	i0	98.126	1	427	8	100	0	1	427	393394	393820	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	427	745	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
19540229	19540229	PRJNA404067_P_NODE_16976_length_252_cov_5.225131_g16589_i0	PRJNA404067	16976	252	5.225131	13.16733012	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g16589	i0	97.222	1	252	7	100	0	1	252	63682	63431	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	252	427	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium
19540695	19540695	PRJNA404067_P_NODE_7956_length_407_cov_2.410405_g7577_i0	PRJNA404067	7956	407	2.410405	9.81034835	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	741	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g7577	i0	99.51	57.2972972972973	408	1	100	1	1	407	974085	974492	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	23320	741	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
23366473	23366473	PRJNA404067_P_NODE_12399_length_298_cov_4.400844_g12013_i0	PRJNA404067	12399	298	4.400844	13.11451512	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	473	4.9899999999999996e-129	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g12013	i0	95.302	1	298	14	100	0	1	298	930664	930367	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	298	473	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
23366483	23366483	PRJNA404067_P_NODE_13179_length_288_cov_5.704846_g12792_i0	PRJNA404067	13179	288	5.704846	16.42995648	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	472	1.73e-128	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g12792	i0	96.181	1	288	11	100	0	1	288	39124	39411	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	288	472	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
23366569	23366569	PRJNA404067_P_NODE_21619_length_232_cov_1.093567_g21232_i0	PRJNA404067	21619	232	1.093567	2.53707544	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	388	1.39e-103	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g21232	i0	97.778	0.969827586206897	225	5	97	0	1	225	635645	635421	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	225	388	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
24033165	24033165	PRJNA404067_P_NODE_40179_length_196_cov_2.585185_g39792_i0	PRJNA404067	40179	196	2.585185	5.0669626	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g39792	i0	99.487	207.341836734694	195	1	99	0	2	196	151852	152046	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	40639	357	0.994397759103641	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium oral taxon 488
24640844	24640844	PRJNA404067_P_NODE_16120_length_258_cov_2.690355_g15733_i0	PRJNA404067	16120	258	2.690355	6.9411159	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	449	7.13e-122	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g15733	i0	98.062	1	258	5	100	0	1	258	124904	124647	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	258	449	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
24640847	24640847	PRJNA404067_P_NODE_16280_length_257_cov_2.000000_g15893_i0	PRJNA404067	16280	257	2	5.14	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	300	7.56e-77	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g15893	i0	88.077	1.01167315175097	260	22	98	2	7	257	1034499	1034240	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	260	300	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis
24640858	24640858	PRJNA404067_P_NODE_17020_length_252_cov_1.534031_g16633_i0	PRJNA404067	17020	252	1.534031	3.86575812	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g16633	i0	99.206	1.37301587301587	252	2	100	0	1	252	309799	309548	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	346	455	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;