metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA768450" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA768450" 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	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
2021420	2021420	PRJNA768450_S_NODE_12422_length_203_cov_1604.298701_g12373_i0	PRJNA768450	12422	203	1604.298701	3256.72636303	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.36e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g12373	i0	97.619	19.8325123152709	42	1	21	162	203	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2021561	2021561	PRJNA768450_S_NODE_1602_length_454_cov_680.074074_g1553_i0	PRJNA768450	1602	454	680.074074	3087.53629596	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	3.38e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g1553	i0	97.619	8.86784140969163	42	1	9	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2021990	2021990	PRJNA768450_S_NODE_4062_length_312_cov_1128.433460_g4013_i0	PRJNA768450	4062	312	1128.43346	3520.7123952	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.24e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g4013	i0	97.619	13.0865384615385	42	1	13	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4083	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4573745	4573745	PRJNA768450_S_NODE_13104_length_199_cov_1551.273333_g13055_i0	PRJNA768450	13104	199	1551.273333	3087.03393267	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.33e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g13055	i0	97.619	20.2311557788945	42	1	21	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4574209	4574209	PRJNA768450_S_NODE_264_length_832_cov_384.454662_g243_i0	PRJNA768450	264	832	384.454662	3198.66278784	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	6.42e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g243	i0	97.619	4.83894230769231	42	1	5	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4574254	4574254	PRJNA768450_S_NODE_3864_length_319_cov_958.703704_g3815_i0	PRJNA768450	3864	319	958.703704	3058.26481576	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.3e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3815	i0	97.619	12.6206896551724	42	1	13	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5848898	5848898	PRJNA768450_S_NODE_11285_length_210_cov_1369.236025_g11236_i0	PRJNA768450	11285	210	1369.236025	2875.3956525	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.41e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g11236	i0	97.619	19.1714285714286	42	1	20	169	210	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5849582	5849582	PRJNA768450_S_NODE_6485_length_260_cov_84.369668_g6436_i0	PRJNA768450	6485	260	84.369668	219.3611368	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.82e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g6436	i0	97.619	15.4846153846154	42	1	16	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7124089	7124089	PRJNA768450_S_NODE_11286_length_210_cov_1369.198758_g11237_i0	PRJNA768450	11286	210	1369.198758	2875.3173918	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.41e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g11237	i0	97.619	19.1714285714286	42	1	20	169	210	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7124718	7124718	PRJNA768450_S_NODE_4386_length_303_cov_1056.212598_g4337_i0	PRJNA768450	4386	303	1056.212598	3200.32417194	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.17e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g4337	i0	97.619	13.2871287128713	42	1	14	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7124721	7124721	PRJNA768450_S_NODE_4446_length_301_cov_1035.626984_g4397_i0	PRJNA768450	4446	301	1035.626984	3117.23722184	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.15e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g4397	i0	97.619	13.375415282392	42	1	14	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8399134	8399134	PRJNA768450_S_NODE_3287_length_341_cov_59.071918_g3238_i0	PRJNA768450	3287	341	59.071918	201.43524038	Nitrospira sp.	70125	Bacteria	Bacteria	65.8	4.14e-6	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3238	i0	97.368	10.5395894428152	38	1	11	1	38	406611	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	3594	65.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9673815	9673815	PRJNA768450_S_NODE_11128_length_211_cov_1538.592593_g11079_i0	PRJNA768450	11128	211	1538.592593	3246.43037123	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.42e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g11079	i0	97.619	19.0805687203791	42	1	20	170	211	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10950001	10950001	PRJNA768450_S_NODE_3069_length_350_cov_491.774086_g3020_i0	PRJNA768450	3069	350	491.774086	1721.209301	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.54e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3020	i0	97.619	11.5028571428571	42	1	12	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
12225069	12225069	PRJNA768450_S_NODE_12250_length_204_cov_1603.264516_g12201_i0	PRJNA768450	12250	204	1603.264516	3270.65961264	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.37e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g12201	i0	97.619	19.7352941176471	42	1	21	163	204	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13499695	13499695	PRJNA768450_S_NODE_3091_length_349_cov_914.226667_g3042_i0	PRJNA768450	3091	349	914.226667	3190.65106783	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.53e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3042	i0	97.619	11.5358166189112	42	1	12	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
14774979	14774979	PRJNA768450_S_NODE_6672_length_257_cov_1166.403846_g6623_i0	PRJNA768450	6672	257	1166.403846	2997.65788422	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.79e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g6623	i0	97.619	15.9066147859922	42	1	16	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4088	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17323766	17323766	PRJNA768450_S_NODE_12934_length_200_cov_1693.682119_g12885_i0	PRJNA768450	12934	200	1693.682119	3387.364238	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.33e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g12885	i0	97.619	20.13	42	1	21	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17323888	17323888	PRJNA768450_S_NODE_16194_length_184_cov_2.096296_g16145_i0	PRJNA768450	16194	184	2.096296	3.85718464	Nitrospira moscoviensis	42253	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g16145	i0	100	0.152173913043478	28	0	15	10	37	1963092	1963119	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
21148537	21148537	PRJNA768450_S_NODE_3897_length_318_cov_918.457249_g3848_i0	PRJNA768450	3897	318	918.457249	2920.69405182	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.29e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3848	i0	97.619	12.6603773584906	42	1	13	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23698809	23698809	PRJNA768450_S_NODE_2399_length_387_cov_795.375740_g2350_i0	PRJNA768450	2399	387	795.37574	3078.1041138	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.84e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g2350	i0	97.619	10.4031007751938	42	1	11	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24971968	24971968	PRJNA768450_S_NODE_1040_length_539_cov_544.048980_g997_i0	PRJNA768450	1040	539	544.04898	2932.4240022	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	4.07e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g997	i0	97.619	7.46938775510204	42	1	8	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24972124	24972124	PRJNA768450_S_NODE_14440_length_192_cov_941.552448_g14391_i0	PRJNA768450	14440	192	941.552448	1807.78070016	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.27e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g14391	i0	97.619	20.96875	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24972751	24972751	PRJNA768450_S_NODE_8020_length_240_cov_1339.502618_g7971_i0	PRJNA768450	8020	240	1339.502618	3214.8062832	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.66e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g7971	i0	97.619	16.775	42	1	18	199	240	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24972772	24972772	PRJNA768450_S_NODE_8540_length_234_cov_1254.886486_g8491_i0	PRJNA768450	8540	234	1254.886486	2936.43437724	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.61e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g8491	i0	97.619	17.2051282051282	42	1	18	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24972787	24972787	PRJNA768450_S_NODE_8820_length_231_cov_97.879121_g8771_i0	PRJNA768450	8820	231	97.879121	226.10076951	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.58e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g8771	i0	97.619	17.4285714285714	42	1	18	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	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);;