metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
450102	450102	PRJNA488043_S_NODE_1141_length_179_cov_46.993333_g1130_i0	PRJNA488043	1141	179	46.993333	84.11806607	Deinococcus aquaticus	328692	Bacteria	Bacteria	326	8.09e-85	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g1130	i0	99.441	209.156424581006	179	1	100	0	1	179	714877	715055	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	37439	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
1097837	1097837	PRJNA488043_P_NODE_10081_length_337_cov_2.448052_g7840_i0	PRJNA488043	10081	337	2.448052	8.24993524	Thermus	270	Bacteria	Bacteria	571	1.97e-158	NTclustered	gi\|2701833777\|dbj\|AP031329.1\|	274	g7840	i0	96.839	285.480712166172	348	0	100	1	1	337	34111	33764	Thermus thermophilus TF24 plasmid pTF24b DNA, complete sequence	blastn	96207	571	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
2373495	2373495	PRJNA488043_P_NODE_6602_length_489_cov_16.504348_g4527_i0	PRJNA488043	6602	489	16.504348	80.70626172	Deinococcus	1298	Bacteria	Bacteria	398	5.32e-106	NTclustered	gi\|2076241620\|gb\|MZ708738.1\|	47478	g4527	i0	97.425	102.685071574642	233	6	80	0	1	233	447	215	Deinococcus sp. strain JXJ CY 31 16S ribosomal RNA gene, partial sequence	blastn	50213	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
4276879	4276879	PRJNA488043_P_NODE_14024_length_242_cov_42.751174_g11782_i0	PRJNA488043	14024	242	42.751174	103.45784108	Deinococcus grandis	57498	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g11782	i0	99.587	182.400826446281	242	1	100	0	1	242	3060876	3060635	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	44141	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
4925990	4925990	PRJNA488043_P_NODE_1484_length_1333_cov_3.037577_g606_i0	PRJNA488043	1484	1333	3.037577	40.49090141	Thermus	270	Bacteria	Bacteria	2394	0	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g606	i0	99.544	47.0960240060015	1317	1	98	1	13	1324	35339	34023	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	62779	2416	0.990894039735099	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
4926046	4926046	PRJNA488043_P_NODE_20924_length_163_cov_1.947761_g18682_i0	PRJNA488043	20924	163	1.947761	3.17485043	Thermus	270	Bacteria	Bacteria	195	2.13e-45	NTclustered	gi\|1886401075\|gb\|CP053288.1\|	274	g18682	i0	100	272.441717791411	105	0	98	0	1	105	90566	90462	Thermus thermophilus strain HB27c plasmid pTT27, complete sequence	blastn	44408	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
4926176	4926176	PRJNA488043_S_NODE_1024_length_188_cov_9.654088_g1013_i0	PRJNA488043	1024	188	9.654088	18.14968544	Deinococcus	1298	Bacteria	Bacteria	265	1.9000000000000001e-66	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g1013	i0	100	184.212765957447	143	0	76	0	5	147	1793658	1793516	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	34632	265	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6827582	6827582	PRJNA488043_P_NODE_9786_length_347_cov_2.383648_g7547_i0	PRJNA488043	9786	347	2.383648	8.27125856	Thermus parvatiensis	456163	Bacteria	Bacteria	531	3.4599999999999992e-146	NTclustered	gi\|982540758\|gb\|CP014142.1\|	456163	g7547	i0	93.036	288.158501440922	359	11	99	3	1	345	124721	125079	Thermus parvatiensis strain RL plasmid pTP143, complete sequence	blastn	99991	531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
7475929	7475929	PRJNA488043_P_NODE_21106_length_161_cov_3.780303_g18864_i0	PRJNA488043	21106	161	3.780303	6.08628783	Deinococcus	1298	Bacteria	Bacteria	250	4.42e-62	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g18864	i0	99.275	449.130434782609	138	1	97	0	10	147	775273	775136	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	72310	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
8102860	8102860	PRJNA488043_P_NODE_11447_length_296_cov_112.614232_g9206_i0	PRJNA488043	11447	296	112.614232	333.33812672	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	481	2.96e-131	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g9206	i0	97.193	95.5101351351351	285	6	96	2	1	284	19306	19589	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	28271	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
8103037	8103037	PRJNA488043_P_NODE_3667_length_747_cov_66.455432_g2035_i0	PRJNA488043	3667	747	66.455432	496.42207704	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1162	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g2035	i0	97.778	290.838018741633	675	14	91	1	1	675	3085867	3086540	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	217256	1162	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
9377766	9377766	PRJNA488043_P_NODE_3108_length_834_cov_32.318012_g1629_i0	PRJNA488043	3108	834	32.318012	269.53222008	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	1271	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g1629	i0	94.265	401.365707434053	837	38	100	9	1	834	74166	74995	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	334739	1271	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
11301303	11301303	PRJNA488043_S_NODE_269_length_339_cov_482.651613_g258_i0	PRJNA488043	269	339	482.651613	1636.18896807	Deinococcus	1298	Bacteria	Bacteria	604	1.9599999999999993e-168	NTclustered	gi\|2095695476\|gb\|OK149243.1\|	47478	g258	i0	98.82	102	339	4	100	0	1	339	765	427	Deinococcus sp. strain ATSAR 16S ribosomal RNA gene, partial sequence	blastn	34578	604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11928596	11928596	PRJNA488043_P_NODE_4710_length_623_cov_2.407407_g2852_i0	PRJNA488043	4710	623	2.407407	14.99814561	Thermus thermophilus	274	Bacteria	Bacteria	1149	0	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g2852	i0	100	164.736757624398	622	0	99	0	1	622	310801	311422	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	102631	1149	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12576843	12576843	PRJNA488043_P_NODE_15050_length_227_cov_2.050505_g12808_i0	PRJNA488043	15050	227	2.050505	4.65464635	Thermus	270	Bacteria	Bacteria	165	2.49e-36	NTclustered	gi\|2701833777\|dbj\|AP031329.1\|	274	g12808	i0	100	208.859030837004	89	0	74	0	139	227	122656	122568	Thermus thermophilus TF24 plasmid pTF24b DNA, complete sequence	blastn	47411	165	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
13203400	13203400	PRJNA488043_P_NODE_11011_length_308_cov_2.684588_g8770_i0	PRJNA488043	11011	308	2.684588	8.26853104	Thermus parvatiensis	456163	Bacteria	Bacteria	549	8.359999999999996e-152	NTclustered	gi\|982540758\|gb\|CP014142.1\|	456163	g8770	i0	99.02	279.571428571429	306	3	99	0	1	306	124774	125079	Thermus parvatiensis strain RL plasmid pTP143, complete sequence	blastn	86108	549	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
13851708	13851708	PRJNA488043_S_NODE_231_length_361_cov_75.463855_g220_i0	PRJNA488043	231	361	75.463855	272.42451655	Deinococcus	1298	Bacteria	Bacteria	628	1.2399999999999997e-175	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g220	i0	98.061	490.495844875346	361	7	100	0	1	361	1792599	1792239	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	177069	628	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18949393	18949393	PRJNA488043_P_NODE_1735_length_1196_cov_3.374464_g747_i0	PRJNA488043	1735	1196	3.374464	40.35858944	Thermus	270	Bacteria	Bacteria	2174	0	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g747	i0	99.915	97.8745819397993	1180	1	99	0	9	1188	190762	189583	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	117058	2185	0.994965675057208	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
19575777	19575777	PRJNA488043_P_NODE_7716_length_429_cov_47.210000_g5544_i0	PRJNA488043	7716	429	47.21	202.5309	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	782	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g5544	i0	99.534	207.592074592075	429	2	100	0	1	429	73212	73640	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	89057	782	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
20224280	20224280	PRJNA488043_P_NODE_1616_length_1264_cov_3.102024_g606_i1	PRJNA488043	1616	1264	3.102024	39.20958336	Thermus	270	Bacteria	Bacteria	1362	0	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g606	i1	99.865	47.1384493670886	740	1	98	0	10	749	34023	34762	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	59583	1365	0.997802197802198	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
22126463	22126463	PRJNA488043_P_NODE_8858_length_378_cov_74.332378_g6639_i0	PRJNA488043	8858	378	74.332378	280.97638884	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	486	8.329999999999999e-133	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g6639	i0	95.146	276.835978835979	309	14	81	1	1	308	75784	76092	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	104644	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
22774845	22774845	PRJNA488043_P_NODE_13598_length_250_cov_2.434389_g11356_i0	PRJNA488043	13598	250	2.434389	6.0859725	Thermus	270	Bacteria	Bacteria	364	2.559999999999999e-96	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g11356	i0	99.5	179.188	200	1	100	0	51	250	136516	136317	Thermus thermophilus TF27 DNA, complete genome	blastn	44797	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
24049957	24049957	PRJNA488043_S_NODE_179_length_390_cov_25.556787_g168_i0	PRJNA488043	179	390	25.556787	99.6714693	Deinococcus	1298	Bacteria	Bacteria	575	1.7899999999999995e-159	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g168	i0	98.176	228.782051282051	329	6	84	0	62	390	714212	713884	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	89225	575	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
25324268	25324268	PRJNA488043_S_NODE_160_length_403_cov_458.101604_g149_i0	PRJNA488043	160	403	458.101604	1846.14946412	Deinococcus	1298	Bacteria	Bacteria	739	0	NTclustered	gi\|2095695476\|gb\|OK149243.1\|	47478	g149	i0	99.752	102.004962779156	403	1	100	0	1	403	74	476	Deinococcus sp. strain ATSAR 16S ribosomal RNA gene, partial sequence	blastn	41108	739	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus 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);;