metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Nitrospirota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2825431	2825431	PRJNA1120203_P_NODE_29703_length_434_cov_3.434903_g28688_i0	PRJNA1120203	29703	434	3.434903	14.90747902	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	802	0	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g28688	i0	100	3	434	0	100	0	1	434	2093932	2094365	Leptospirillum ferriphilum ML-04, complete genome	blastn	1302	802	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
4855959	4855959	PRJNA1120203_P_NODE_62424_length_285_cov_1.089623_g61408_i0	PRJNA1120203	62424	285	1.089623	3.10542555	Leptospirillum	179	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g61408	i0	100	6.16491228070175	284	0	99	0	2	285	1264246	1263963	Leptospirillum ferriphilum ML-04, complete genome	blastn	1757	525	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
5378344	5378344	PRJNA1120203_P_NODE_69585_length_269_cov_1.408163_g68569_i0	PRJNA1120203	69585	269	1.408163	3.78795847	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|640837746\|gb\|CP007243.1\|	1441628	g68569	i0	99.628	3	269	1	100	0	1	269	1044532	1044800	Leptospirillum ferriphilum YSK, complete genome	blastn	807	492	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
6130630	6130630	PRJNA1120203_P_NODE_39545_length_363_cov_23.834483_g38530_i0	PRJNA1120203	39545	363	23.834483	86.51917329	Leptospirillum	179	Bacteria	Bacteria	651	0	NTclustered	gi\|559113930\|tpe\|HG525824.1\|	419542	g38530	i0	99.441	5.91735537190083	358	2	99	0	6	363	1	358	TPA: Leptospirillum rubarum tmRNA gene Lepto_sp_GroII	blastn	2148	651	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum rubarum
9203514	9203514	PRJNA1120203_P_NODE_92828_length_246_cov_0.890173_g91812_i0	PRJNA1120203	92828	246	0.890173	2.18982558	Thermodesulfovibrionales bacterium	2814272	Bacteria	Bacteria	163	9.84e-36	NTclustered	gi\|2874253970\|emb\|OY970295.1\|	2814272	g91812	i0	87.5	43.3373983739837	144	15	59	2	1	144	1174745	1174885	MAG: Thermodesulfovibrionales bacterium isolate MFD01299.bin.c.3 genome assembly, chromosome: 1	blastn	10661	163	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales			Thermodesulfovibrionales bacterium
11231443	11231443	PRJNA1120203_P_NODE_83209_length_249_cov_1.306818_g82193_i0	PRJNA1120203	83209	249	1.306818	3.25397682	Leptospirillum	179	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g82193	i0	99.598	3	249	1	100	0	1	249	801456	801208	Leptospirillum ferriphilum ML-04, complete genome	blastn	747	455	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
11753501	11753501	PRJNA1120203_P_NODE_52370_length_312_cov_1.288703_g51354_i0	PRJNA1120203	52370	312	1.288703	4.02075336	Leptospirillum sp. Group II 'CF-1'	1660083	Bacteria	Bacteria	575	1.3999999999999999e-159	NTclustered	gi\|902829180\|gb\|CP012147.1\|	1660083	g51354	i0	100	2.99038461538462	311	0	99	0	2	312	2000062	2000372	Leptospirillum sp. Group II 'CF-1', complete genome	blastn	933	575	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum sp. Group II 'CF-1'
14304272	14304272	PRJNA1120203_P_NODE_81672_length_250_cov_0.870056_g80656_i0	PRJNA1120203	81672	250	0.870056	2.17514	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|640837746\|gb\|CP007243.1\|	1441628	g80656	i0	100	2.96	250	0	100	0	1	250	2054528	2054279	Leptospirillum ferriphilum YSK, complete genome	blastn	740	462	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
16851802	16851802	PRJNA1120203_P_NODE_102174_length_242_cov_0.911243_g101158_i0	PRJNA1120203	102174	242	0.911243	2.20520806	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	444	3.08e-120	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g101158	i0	100	1.98347107438017	240	0	99	0	1	240	2156891	2156652	Leptospirillum ferriphilum ML-04, complete genome	blastn	480	444	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
19400406	19400406	PRJNA1120203_P_NODE_103936_length_241_cov_1.345238_g102920_i0	PRJNA1120203	103936	241	1.345238	3.24202358	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g102920	i0	99.585	3	241	1	100	0	1	241	2103033	2102793	Leptospirillum ferriphilum ML-04, complete genome	blastn	723	440	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
19401309	19401309	PRJNA1120203_P_NODE_82636_length_250_cov_0.870056_g81620_i0	PRJNA1120203	82636	250	0.870056	2.17514	Nitrospira defluvii	330214	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g81620	i0	98.8	1	250	3	100	0	1	250	4055624	4055873	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	250	446	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
21429603	21429603	PRJNA1120203_P_NODE_23377_length_514_cov_1.748299_g22365_i0	PRJNA1120203	23377	514	1.748299	8.98625686	Leptospirillum	179	Bacteria	Bacteria	935	0	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g22365	i0	99.609	6.97081712062257	512	2	99	0	3	514	1751778	1752289	Leptospirillum ferriphilum ML-04, complete genome	blastn	3583	935	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
22704641	22704641	PRJNA1120203_P_NODE_36398_length_381_cov_3.931818_g35383_i0	PRJNA1120203	36398	381	3.931818	14.98022658	Leptospirillum	179	Bacteria	Bacteria	704	0	NTclustered	gi\|406772829\|gb\|CP002919.1\|	1048260	g35383	i0	100	27.9422572178478	381	0	100	0	1	381	2098074	2098454	Leptospirillum ferriphilum ML-04, complete genome	blastn	10646	704	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
23227981	23227981	PRJNA1120203_P_NODE_99659_length_243_cov_0.905882_g98643_i0	PRJNA1120203	99659	243	0.905882	2.20129326	Leptospirillum ferriphilum	178606	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|640837746\|gb\|CP007243.1\|	1441628	g98643	i0	100	3	243	0	100	0	1	243	1798008	1798250	Leptospirillum ferriphilum YSK, complete genome	blastn	729	449	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum

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);;