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

15 rows where analysis = "blastn", bioproject = "PRJNA520845" 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
489476	489476	PRJNA520845_P_NODE_187941_length_271_cov_1.878788_g186442_i0	PRJNA520845	187941	271	1.878788	5.09151548	Deinococcus yunweiensis	367282	Bacteria	Bacteria	176	1.41e-39	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g186442	i0	79.297	1.86346863468635	256	50	94	3	8	262	994598	994851	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	505	176	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
1763592	1763592	PRJNA520845_P_NODE_144742_length_310_cov_2.472574_g143243_i0	PRJNA520845	144742	310	2.472574	7.6649794	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	145	4.6399999999999994e-30	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g143243	i0	84.667	11.4290322580645	150	17	95	5	1	147	2269559	2269413	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	3543	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
3662937	3662937	PRJNA520845_P_NODE_237803_length_247_cov_0.885057_g236304_i0	PRJNA520845	237803	247	0.885057	2.18609079	Thermus	270	Bacteria	Bacteria	455	1.4600000000000002e-123	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g236304	i0	100	11.8663967611336	246	0	99	0	2	247	743183	743428	Thermus scotoductus SA-01, complete genome	blastn	2931	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
4316142	4316142	PRJNA520845_P_NODE_177944_length_279_cov_1.529126_g176445_i0	PRJNA520845	177944	279	1.529126	4.26626154	Deinococcus grandis	57498	Bacteria	Bacteria	274	5.04e-69	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g176445	i0	96.407	6.26164874551971	167	5	59	1	1	166	92495	92329	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1747	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8764609	8764609	PRJNA520845_P_NODE_223387_length_249_cov_1.312500_g221888_i0	PRJNA520845	223387	249	1.3125	3.268125	Bacteria	2	Bacteria	Bacteria	108	4.74e-19	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g221888	i0	98.361	27.2570281124498	61	1	24	0	54	114	1598059	1597999	Deinococcus proteolyticus MRP, complete genome	blastn	6787	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
9419208	9419208	PRJNA520845_P_NODE_243048_length_245_cov_3.779070_g241549_i0	PRJNA520845	243048	245	3.77907	9.2587215	Deinococcus aquaticus	328692	Bacteria	Bacteria	183	7.519999999999998e-42	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g241549	i0	83.085	0.820408163265306	201	34	82	0	8	208	1787753	1787553	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	201	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
10040063	10040063	PRJNA520845_P_NODE_202888_length_259_cov_1.618280_g201389_i0	PRJNA520845	202888	259	1.61828	4.1913452	Deinococcus	1298	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g201389	i0	88.889	57.8069498069498	234	26	90	0	10	243	225467	225234	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	14972	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10694379	10694379	PRJNA520845_P_NODE_225549_length_249_cov_0.875000_g224050_i0	PRJNA520845	225549	249	0.875	2.17875	Deinococcus aquaticus	328692	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g224050	i0	81.526	1.46184738955823	249	19	100	6	1	249	862764	862543	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	364	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11968175	11968175	PRJNA520845_P_NODE_184590_length_274_cov_1.388060_g183091_i0	PRJNA520845	184590	274	1.38806	3.8032844	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	364	2.8499999999999992e-96	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g183091	i0	91.078	1.9014598540146	269	24	98	0	1	269	2325002	2325270	Deinococcus sp. NW-56 chromosome, complete genome	blastn	521	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12590669	12590669	PRJNA520845_P_NODE_244370_length_245_cov_0.895349_g242871_i0	PRJNA520845	244370	245	0.895349	2.19360505	Deinococcus	1298	Bacteria	Bacteria	95.3	3.62e-15	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g242871	i0	78.912	1.18775510204082	147	26	60	4	100	245	2079628	2079486	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	291	95.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
14520337	14520337	PRJNA520845_P_NODE_258592_length_242_cov_1.508876_g257093_i0	PRJNA520845	258592	242	1.508876	3.65147992	Deinococcus ficus	317577	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g257093	i0	97.934	1	242	5	100	0	1	242	19131	19372	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	242	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
19617494	19617494	PRJNA520845_P_NODE_259896_length_242_cov_0.911243_g258397_i0	PRJNA520845	259896	242	0.911243	2.20520806	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g258397	i0	99.587	49.3471074380165	242	1	100	0	1	242	315318	315559	Thermus sp. NEB1569 chromosome, complete genome	blastn	11942	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20237992	20237992	PRJNA520845_P_NODE_203756_length_258_cov_2.410811_g202257_i0	PRJNA520845	203756	258	2.410811	6.21989238	Deinococcus	1298	Bacteria	Bacteria	241	4.67e-59	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g202257	i0	83.658	6.27906976744186	257	40	99	2	3	258	1737846	1738101	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	1620	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
20893138	20893138	PRJNA520845_P_NODE_247177_length_245_cov_0.895349_g245678_i0	PRJNA520845	247177	245	0.895349	2.19360505	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g245678	i0	80.816	27.9510204081633	245	47	100	0	1	245	1762438	1762194	Deinococcus sp. QL22 chromosome, complete genome	blastn	6848	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
23441599	23441599	PRJNA520845_P_NODE_174339_length_282_cov_1.473684_g172840_i0	PRJNA520845	174339	282	1.473684	4.15578888	Deinococcus ficus	317577	Bacteria	Bacteria	206	1.8899999999999994e-48	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g172840	i0	80.292	3.9290780141844	274	52	97	2	10	282	1678210	1677938	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	1108	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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