metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA724011" 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
3261811	3261811	PRJNA724011_P_NODE_26283_length_549_cov_2.579832_g25267_i0	PRJNA724011	26283	549	2.579832	14.16327768	Thermotoga caldifontis	1508419	Bacteria	Bacteria	62.1	8.97e-5	NTclustered	gi\|597439397\|dbj\|AP014509.1\|	1408159	g25267	i0	94.872	0.0710382513661202	39	2	7	0	149	187	240180	240218	Thermotoga caldifontis AZM44c09 DNA, complete genome	blastn	39	62.1	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga caldifontis
7089636	7089636	PRJNA724011_P_NODE_76246_length_285_cov_3.797170_g75223_i0	PRJNA724011	76246	285	3.79717	10.8219345	Deinococcus gobiensis	502394	Bacteria	Bacteria	477	3.669999999999999e-130	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g75223	i0	96.853	203.00701754386	286	8	100	1	1	285	112169	112454	Deinococcus gobiensis I-0, complete genome	blastn	57857	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8846805	8846805	PRJNA724011_P_NODE_2447_length_1857_cov_15.352578_g2111_i1	PRJNA724011	2447	1857	15.352578	285.09737345999997	Deinococcus	1298	Bacteria	Bacteria	2804	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2111	i1	94.035	310.893914916532	1861	92	99	17	4	1855	1851	1	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	577330	2808	0.998575498575499	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9638891	9638891	PRJNA724011_P_NODE_110288_length_241_cov_0.916667_g109265_i0	PRJNA724011	110288	241	0.916667	2.20916747	Thermus thermophilus	274	Bacteria	Bacteria	274	4.2499999999999997e-69	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g109265	i0	87.983	2.89211618257261	233	26	96	2	1	232	310476	310707	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	697	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
10914904	10914904	PRJNA724011_P_NODE_75029_length_288_cov_1.609302_g74006_i0	PRJNA724011	75029	288	1.609302	4.63478976	Deinococcus proteolyticus	55148	Bacteria	Bacteria	65.8	3.42e-6	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g74006	i0	91.489	0.163194444444444	47	4	16	0	107	153	1217543	1217589	Deinococcus proteolyticus MRP, complete genome	blastn	47	65.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
16013550	16013550	PRJNA724011_P_NODE_99033_length_248_cov_0.880000_g98010_i0	PRJNA724011	99033	248	0.88	2.1824	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	420	5.34e-113	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g98010	i0	97.189	2.89516129032258	249	5	100	2	1	248	562687	562440	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	718	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
19837776	19837776	PRJNA724011_P_NODE_75236_length_288_cov_1.190698_g74213_i0	PRJNA724011	75236	288	1.190698	3.42921024	Deinococcus aquaticus	328692	Bacteria	Bacteria	326	1.42e-84	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g74213	i0	92.208	3.40625	231	16	80	2	59	288	789694	789923	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	981	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
20320221	20320221	PRJNA724011_P_NODE_18416_length_691_cov_11.880259_g17414_i0	PRJNA724011	18416	691	11.880259	82.09258969	Deinococcus	1298	Bacteria	Bacteria	1142	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g17414	i0	97.741	203.261939218524	664	13	96	1	4	665	1851	1188	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	140454	1142	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
21113444	21113444	PRJNA724011_P_NODE_77457_length_283_cov_1.214286_g76434_i0	PRJNA724011	77457	283	1.214286	3.43642938	Deinococcus yunweiensis	367282	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g76434	i0	100	167.04593639576	283	0	100	0	1	283	2671584	2671866	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	47274	523	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
21596119	21596119	PRJNA724011_P_NODE_48937_length_371_cov_2.315436_g47914_i0	PRJNA724011	48937	371	2.315436	8.59026756	Bacteria	2	Bacteria	Bacteria	686	0	NTclustered	gi\|155128\|gb\|J04639.1\|TTHTAQP1A	271	g47914	i0	100	66.4474393530997	371	0	100	0	1	371	274	644	Thermus aquaticus DNA polymerase (PolI) gene	blastn	24652	686	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
22387972	22387972	PRJNA724011_P_NODE_27638_length_532_cov_3.786492_g26622_i0	PRJNA724011	27638	532	3.786492	20.14413744	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	957	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g26622	i0	99.245	415.385338345865	530	4	99	0	3	532	58233	57704	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	220985	957	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
22871253	22871253	PRJNA724011_P_NODE_106118_length_243_cov_0.905882_g105095_i0	PRJNA724011	106118	243	0.905882	2.20129326	Deinococcus	1298	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g105095	i0	99.177	191.362139917695	243	2	100	0	1	243	715104	715346	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	46501	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis

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