metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax_kingdom = "Thermotogati"

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
476853	476853	PRJNA495391_S_NODE_52321_length_171_cov_2.051471_g51269_i0	PRJNA495391	52321	171	2.051471	3.50801541	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	283	4.67e-72	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g51269	i0	96.491	151.690058479532	171	6	100	0	1	171	70594	70764	Deinococcus sp. D7000 chromosome, complete genome	blastn	25939	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
1106908	1106908	PRJNA495391_S_NODE_15981_length_299_cov_4.405303_g14929_i0	PRJNA495391	15981	299	4.405303	13.17185597	Truepera	332248	Bacteria	Bacteria	364	3.1399999999999986e-96	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g14929	i0	88.629	374.698996655518	299	34	100	0	1	299	209	507	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	112035	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3658717	3658717	PRJNA495391_S_NODE_5683_length_519_cov_5.438017_g4648_i0	PRJNA495391	5683	519	5.438017	28.22330823	Deinococcus	1298	Bacteria	Bacteria	854	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g4648	i0	96.353	206.104046242775	521	15	100	3	1	519	69893	69375	Deinococcus swuensis strain DY59, complete genome	blastn	106968	854	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
5579358	5579358	PRJNA495391_S_NODE_16085_length_298_cov_8.049430_g15033_i0	PRJNA495391	16085	298	8.04943	23.9873014	Deinococcus altitudinis	468914	Bacteria	Bacteria	488	1.78e-133	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g15033	i0	96.296	285.147651006711	297	11	99	0	1	297	413800	413504	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	84974	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
10036110	10036110	PRJNA495391_S_NODE_5828_length_511_cov_8.186975_g4793_i0	PRJNA495391	5828	511	8.186975	41.83544225	Deinococcus	1298	Bacteria	Bacteria	832	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g4793	i0	96.086	345.702544031311	511	19	100	1	1	511	1792090	1792599	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	176654	832	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
15135362	15135362	PRJNA495391_S_NODE_33732_length_209_cov_123.201149_g32680_i0	PRJNA495391	33732	209	123.201149	257.49040141	Truepera	332248	Bacteria	Bacteria	268	1.6699999999999994e-67	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g32680	i0	89.952	148.933014354067	209	20	100	1	1	209	221	14	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	31127	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
15778620	15778620	PRJNA495391_S_NODE_2233_length_925_cov_23.361798_g1369_i0	PRJNA495391	2233	925	23.361798	216.0966315	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1160	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g1369	i0	89.158	562.201081081081	950	77	100	10	1	925	3600154	3601102	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	520036	1160	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
19602003	19602003	PRJNA495391_S_NODE_25876_length_237_cov_1.876238_g24824_i0	PRJNA495391	25876	237	1.876238	4.44668406	Pyramidobacter sp. YE332	3068894	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2601021520\|gb\|CP133038.1\|	3068894	g24824	i0	100	0.122362869198312	29	0	12	0	162	190	55520	55492	Pyramidobacter sp. YE332 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter sp. YE332
20234084	20234084	PRJNA495391_S_NODE_6576_length_479_cov_7.918919_g5534_i0	PRJNA495391	6576	479	7.918919	37.93162201	Deinococcus	1298	Bacteria	Bacteria	669	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g5534	i0	92.842	343.76617954071	461	33	96	0	1	461	1792599	1792139	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	164664	669	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23428520	23428520	PRJNA495391_S_NODE_27119_length_231_cov_5.831633_g26067_i0	PRJNA495391	27119	231	5.831633	13.47107223	Trueperaceae bacterium	2026798	Bacteria	Bacteria	278	3.13e-70	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g26067	i0	88.412	147.575757575758	233	24	100	2	1	231	7907	8138	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	34090	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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