metadata: contig_metadata: 15 rows where bioproject = "PRJNA608660" and tax

15 rows where bioproject = "PRJNA608660" 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
4412161	4412161	PRJNA608660_P_NODE_15884_length_365_cov_2.541139_g15530_i0	PRJNA608660	15884	365	2.541139	9.27515735	Nitrospira moscoviensis	42253	Bacteria	Bacteria	540	6.06e-149	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g15530	i0	95.044	211.619178082192	343	17	94	0	10	352	1277252	1277594	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	77241	540	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
4412465	4412465	PRJNA608660_P_NODE_48184_length_164_cov_8.956522_g47827_i0	PRJNA608660	48184	164	8.956522	14.68869608	Nitrospirota bacterium	2026887	Bacteria	Bacteria	235	1.27e-57	NTclustered	gi\|2621702110\|emb\|OY760142.1\|	2026887	g47827	i0	95.862	357.493902439024	145	6	88	0	9	153	1460311	1460455	MAG: Nitrospirota bacterium isolate 41fe4016-ed88-40a2-aca4-2b8d86c50af7 genome assembly, chromosome: 1	blastn	58629	235	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
7524693	7524693	PRJNA608660_P_NODE_20086_length_314_cov_7.671698_g19730_i0	PRJNA608660	20086	314	7.671698	24.08913172	Nitrospira	1234	Bacteria	Bacteria	503	6.75e-138	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g19730	i0	96.104	270.127388535032	308	12	98	0	1	308	1278063	1278370	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	84820	508	0.990157480314961	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
8237587	8237587	PRJNA608660_P_NODE_1007_length_1119_cov_15.976636_g872_i0	PRJNA608660	1007	1119	15.976636	178.77855684	Nitrospira moscoviensis	42253	Bacteria	Bacteria	1725	0	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g872	i0	94.995	441.078641644325	1099	55	98	0	10	1108	1278005	1279103	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	493567	1725	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
13900973	13900973	PRJNA608660_P_NODE_50991_length_152_cov_8.961165_g50634_i0	PRJNA608660	50991	152	8.961165	13.6209708	Nitrospira	1234	Bacteria	Bacteria	243	6.87e-60	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g50634	i0	97.857	104.092105263158	140	3	92	0	11	150	1279712	1279573	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	15822	243	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
15887570	15887570	PRJNA608660_P_NODE_2693_length_822_cov_7.014230_g2467_i0	PRJNA608660	2693	822	7.01423	57.6569706	Nitrospira sp.	70125	Bacteria	Bacteria	325	8.189999999999999e-109	NR	MBH0187608.1	70125	g2467	i0	97	1.82846715328467	167	5	60.9	0	18	518	83	249	MBH0187608.1 aldehyde dehydrogenase family protein [Nitrospira sp.]	diamond	1503	325	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19711120	19711120	PRJNA608660_P_NODE_14656_length_383_cov_2.023952_g14303_i0	PRJNA608660	14656	383	2.023952	7.75173616	Nitrospira	1234	Bacteria	Bacteria	123	9.11e-30	NR	WP_087473321.1	96242	g14303	i0	96.9	1.01827676240209	65	2	50.9	0	272	78	1	65	WP_087473321.1 ATP-binding protein [Nitrospira cf. moscoviensis SBR1015]	diamond	390	123	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira cf. moscoviensis SBR1015
21548851	21548851	PRJNA608660_P_NODE_36897_length_200_cov_5.529801_g36541_i0	PRJNA608660	36897	200	5.529801	11.059602	Nitrospira	1234	Bacteria	Bacteria	255	1.23e-63	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g36541	i0	98.611	130.175	144	2	100	0	57	200	2094146	2094289	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	26035	255	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21548884	21548884	PRJNA608660_P_NODE_46377_length_168_cov_0.873950_g46020_i0	PRJNA608660	46377	168	0.87395	1.468236	Nitrospira lenta	1436998	Bacteria	Bacteria	90.9	1.51e-20	NR	WP_121990699.1	1436998	g46020	i0	100	0.785714285714286	44	0	78.6	0	35	166	56	99	WP_121990699.1 30S ribosomal protein S2 [Nitrospira lenta]	diamond	132	90.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
28027743	28027743	PRJNA608660_P_NODE_11425_length_440_cov_7.749361_g11078_i0	PRJNA608660	11425	440	7.749361	34.0971884	Nitrospira sp. ST-bin4	1978764	Bacteria	Bacteria	75.1	2.97e-13	NR	OQW59010.1	1978764	g11078	i0	100	0.225	33	0	22.5	0	302	400	1	33	OQW59010.1 MAG: hypothetical protein BVN28_10975 [Nitrospira sp. ST-bin4]	diamond	99	75.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. ST-bin4
29177637	29177637	PRJNA608660_P_NODE_48549_length_164_cov_0.904348_g48192_i0	PRJNA608660	48549	164	0.904348	1.48313072	Nitrospira	1234	Bacteria	Bacteria	109	1.78e-27	NR	MBH0184527.1	70125	g48192	i0	98.1	3.95121951219512	54	1	98.8	0	2	163	35	88	MBH0184527.1 alanine--glyoxylate aminotransferase family protein [Nitrospira sp.]	diamond	648	109	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29543110	29543110	PRJNA608660_P_NODE_46010_length_168_cov_1.697479_g45653_i0	PRJNA608660	46010	168	1.697479	2.85176472	Nitrospira cf. moscoviensis SBR1	96242	Bacteria	Bacteria	92.4	4.36e-20	NR	WP_087474318.1	96242	g45653	i0	100	0.75	42	0	75	0	168	43	28	69	WP_087474318.1 PEP/pyruvate-binding domain-containing protein [Nitrospira cf. moscoviensis SBR1015]	diamond	126	92.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira cf. moscoviensis SBR1015
30238087	30238087	PRJNA608660_P_NODE_15252_length_374_cov_1.812308_g14899_i0	PRJNA608660	15252	374	1.812308	6.77803192	Nitrospira sp.	70125	Bacteria	Bacteria	195	5.48e-58	NR	HEY7130345.1	70125	g14899	i0	84.9	0.850267379679144	106	15	85	1	9	326	145	249	HEY7130345.1 DUF4038 domain-containing protein [Nitrospira sp.]	diamond	318	195	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31818437	31818437	PRJNA608660_P_NODE_39917_length_188_cov_3.546763_g39560_i0	PRJNA608660	39917	188	3.546763	6.66791444	Nitrospira sp.	70125	Bacteria	Bacteria	92.4	8.910000000000001e-21	NR	MEQ1627923.1	70125	g39560	i0	93.5	0.734042553191489	46	3	73.4	0	144	7	1	46	MEQ1627923.1 DUF6502 family protein [Nitrospira sp.]	diamond	138	92.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32243338	32243338	PRJNA608660_P_NODE_5938_length_602_cov_9.504521_g5627_i0	PRJNA608660	5938	602	9.504521	57.21721642	Nitrospira	1234	Bacteria	Bacteria	216	8.169999999999999e-62	NR	MBH0190253.1	70125	g5627	i0	99.1	1.08637873754153	109	1	54.3	0	265	591	567	675	MBH0190253.1 hypothetical protein [Nitrospira sp.]	diamond	654	217	0.995391705069124	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.

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