metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax_phylum = "Thermodesulfobacteriota"

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
744058	744058	PRJNA763243_P_NODE_73061_length_206_cov_4.458647_g72715_i0	PRJNA763243	73061	206	4.458647	9.18481282	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	209	1.01e-49	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g72715	i0	87.845	114.45145631068	181	19	87	3	4	182	164330	164509	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	23577	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
2480724	2480724	PRJNA763243_P_NODE_50802_length_253_cov_0.911111_g50456_i0	PRJNA763243	50802	253	0.911111	2.30511083	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	363	9.339999999999996e-96	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g50456	i0	94.118	471.241106719368	238	14	94	0	4	241	226298	226535	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	119224	363	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
4572321	4572321	PRJNA763243_P_NODE_70244_length_219_cov_6.287671_g69898_i0	PRJNA763243	70244	219	6.287671	13.76999949	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	254	4.95e-63	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g69898	i0	89.604	205.100456621005	202	18	91	3	2	201	164408	164608	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	44917	254	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
9672530	9672530	PRJNA763243_P_NODE_73928_length_202_cov_11.713178_g73582_i0	PRJNA763243	73928	202	11.713178	23.66061956	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	200	5.929999999999999e-47	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g73582	i0	84.878	233.346534653465	205	23	99	8	1	199	493205	493003	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	47136	200	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
13496703	13496703	PRJNA763243_P_NODE_27131_length_313_cov_1.620833_g26785_i0	PRJNA763243	27131	313	1.620833	5.07320729	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	381	3.289999999999999e-101	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g26785	i0	89.542	251.134185303514	306	24	96	6	3	303	1255416	1255718	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	78605	381	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
14771774	14771774	PRJNA763243_P_NODE_2312_length_867_cov_17.265743_g2068_i0	PRJNA763243	2312	867	17.265743	149.69399181	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	933	0	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g2068	i0	86.338	283.953863898501	871	101	99	17	2	865	1254314	1255173	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	246188	933	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
15233611	15233611	PRJNA763243_P_NODE_10112_length_472_cov_3.210526_g9769_i0	PRJNA763243	10112	472	3.210526	15.15368272	Oleidesulfovibrio	2909705	Bacteria	Bacteria	473	8.269999999999999e-129	NTclustered	gi\|470477329\|ref\|NR_076377.1\|	58180	g9769	i0	85.288	306.701271186441	469	58	98	10	11	472	11	475	Desulfovibrio alaskensis strain G20 23S ribosomal RNA gene, complete sequence	blastn	144763	473	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oleidesulfovibrio	Oleidesulfovibrio alaskensis
15233700	15233700	PRJNA763243_P_NODE_292_length_1906_cov_12.763230_g231_i0	PRJNA763243	292	1906	12.76323	243.2671638	Oleidesulfovibrio	2909705	Bacteria	Bacteria	1844	0	NTclustered	gi\|470477329\|ref\|NR_076377.1\|	58180	g231	i0	84.575	275.285939139559	1906	243	98	43	33	1905	1	1888	Desulfovibrio alaskensis strain G20 23S ribosomal RNA gene, complete sequence	blastn	524695	1849	0.997295835586804	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oleidesulfovibrio	Oleidesulfovibrio alaskensis
16045295	16045295	PRJNA763243_P_NODE_1293_length_1089_cov_9.834646_g1113_i0	PRJNA763243	1293	1089	9.834646	107.09929494	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	1123	0	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g1113	i0	85.494	294.081726354454	1103	130	99	26	1	1086	165130	164041	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	320255	1123	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
16508239	16508239	PRJNA763243_P_NODE_72333_length_209_cov_6.772059_g71987_i0	PRJNA763243	72333	209	6.772059	14.15360331	Desulfovibrionaceae	194924	Bacteria	Bacteria	285	1.6599999999999998e-72	NTclustered	gi\|1863422180\|gb\|CP045504.1\|	1121464	g71987	i0	92.157	253.693779904306	204	12	97	4	3	204	1153525	1153324	Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome	blastn	53022	285	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfodismutans
19870238	19870238	PRJNA763243_P_NODE_44776_length_265_cov_3.453125_g44430_i0	PRJNA763243	44776	265	3.453125	9.15078125	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	309	1.3e-79	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g44430	i0	88.077	181.901886792453	260	31	98	0	3	262	164374	164115	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	48204	309	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
21145898	21145898	PRJNA763243_P_NODE_41917_length_272_cov_1.648241_g41571_i0	PRJNA763243	41917	272	1.648241	4.48321552	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	248	2.97e-61	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g41571	i0	94.444	108.238970588235	162	7	59	1	21	180	2966903	2966742	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	29441	248	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
21607283	21607283	PRJNA763243_P_NODE_13157_length_420_cov_2307.504323_g12812_i0	PRJNA763243	13157	420	2307.504323	9691.5181566	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	333	1.29e-86	NTclustered	gi\|470481435\|ref\|NR_076474.1\|	881	g12812	i0	87.329	288.707142857143	292	35	69	2	128	417	302	11	Desulfovibrio vulgaris strain DP4 23S ribosomal RNA gene, complete sequence	blastn	121257	333	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
22421209	22421209	PRJNA763243_P_NODE_67738_length_229_cov_3.410256_g67392_i0	PRJNA763243	67738	229	3.410256	7.80948624	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	322	1.41e-83	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g67392	i0	92.511	262.475982532751	227	14	98	3	1	225	226094	226319	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	60107	322	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
24969308	24969308	PRJNA763243_P_NODE_15420_length_393_cov_1.631250_g15075_i0	PRJNA763243	15420	393	1.63125	6.4108125	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	508	1.86e-139	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g15075	i0	90.306	336.64631043257	392	32	99	5	4	393	3034018	3034405	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	132302	508	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis

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