metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
947736	947736	PRJNA976345_P_NODE_120001_length_178_cov_2.727273_g118393_i0	PRJNA976345	120001	178	2.727273	4.85454594	Deinococcus aquaticus	328692	Bacteria	Bacteria	128	2.43e-25	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g118393	i0	97.333	1.66292134831461	75	2	42	0	1	75	515795	515869	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	296	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
947758	947758	PRJNA976345_P_NODE_123401_length_178_cov_2.139860_g121793_i0	PRJNA976345	123401	178	2.13986	3.8089508	Deinococcus rubellus	1889240	Bacteria	Bacteria	100	5.3e-17	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g121793	i0	90.789	1.14606741573034	76	6	42	1	104	178	1272506	1272581	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	204	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
2223531	2223531	PRJNA976345_P_NODE_197042_length_150_cov_3.078261_g195434_i0	PRJNA976345	197042	150	3.078261	4.6173915	Marinitoga aeolica	2809031	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2498963055\|gb\|CP069362.1\|	2809031	g195434	i0	100	0.193333333333333	29	0	19	0	46	74	746678	746706	Marinitoga aeolica strain BP5-C20A chromosome, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
6051725	6051725	PRJNA976345_P_NODE_41205_length_268_cov_3.274678_g39597_i0	PRJNA976345	41205	268	3.274678	8.77613704	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	340	4.68e-89	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g39597	i0	90.335	516.682835820896	269	12	100	8	1	268	68449	68194	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	138471	340	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6371073	6371073	PRJNA976345_P_NODE_127645_length_176_cov_3.808511_g126037_i0	PRJNA976345	127645	176	3.808511	6.70297936	Thermus	270	Bacteria	Bacteria	169	1.4099999999999998e-37	NTclustered	gi\|2199613095\|dbj\|AP025600.1\|	274	g126037	i0	100	3.61931818181818	91	0	52	0	86	176	2042	1952	Thermus thermophilus SNM1-1 plasmid pTthSNM1-1e DNA, complete sequence	blastn	637	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7645594	7645594	PRJNA976345_P_NODE_86506_length_200_cov_1.745455_g84898_i0	PRJNA976345	86506	200	1.745455	3.49091	Deinococcus	1298	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g84898	i0	99.5	27.065	200	1	100	0	1	200	2280948	2281147	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	5413	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12427078	12427078	PRJNA976345_P_NODE_143590_length_169_cov_1.686567_g141982_i0	PRJNA976345	143590	169	1.686567	2.85029823	Deinococcus radiopugnans	57497	Bacteria	Bacteria	268	1.29e-67	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g141982	i0	95.266	187.792899408284	169	8	100	0	1	169	69203	69371	Deinococcus swuensis strain DY59, complete genome	blastn	31737	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
13702159	13702159	PRJNA976345_P_NODE_40791_length_269_cov_442.111111_g39183_i0	PRJNA976345	40791	269	442.111111	1189.27888859	Oceanotoga sp. DSM 15011	2984951	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2321114327\|gb\|CP107547.1\|	2984951	g39183	i0	100	0.211895910780669	29	0	11	0	238	266	245060	245032	Oceanotoga sp. DSM 15011 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Oceanotoga	Oceanotoga sp. DSM 15011
17525805	17525805	PRJNA976345_P_NODE_122934_length_178_cov_2.216783_g121326_i0	PRJNA976345	122934	178	2.216783	3.94587374	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	102	1.47e-17	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g121326	i0	91.781	0.567415730337079	73	6	41	0	104	176	2622382	2622454	Deinococcus sp. AJ005 chromosome, complete genome	blastn	101	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
17525884	17525884	PRJNA976345_P_NODE_135774_length_173_cov_0.818841_g134166_i0	PRJNA976345	135774	173	0.818841	1.41659493	Thermus thermophilus	274	Bacteria	Bacteria	250	4.8e-62	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g134166	i0	92.982	20.971098265896	171	12	99	0	3	173	281330	281500	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	3628	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
17525997	17525997	PRJNA976345_P_NODE_15194_length_435_cov_5.322500_g13609_i0	PRJNA976345	15194	435	5.3225	23.152875	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	593	5.569999999999998e-165	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g13609	i0	91.196	207.475862068966	443	29	100	7	1	435	74357	74797	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	90252	593	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
20074715	20074715	PRJNA976345_P_NODE_18516_length_392_cov_1.694678_g16921_i0	PRJNA976345	18516	392	1.694678	6.64313776	Deinococcus aetherius	200252	Bacteria	Bacteria	206	2.7199999999999994e-48	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g16921	i0	80.556	2.94642857142857	288	38	72	9	7	287	501186	500910	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1155	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
20393894	20393894	PRJNA976345_P_NODE_87816_length_199_cov_1.615854_g86208_i0	PRJNA976345	87816	199	1.615854	3.21554946	Thermus	270	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g86208	i0	100	5	199	0	100	0	1	199	229756	229558	Thermus scotoductus SA-01, complete genome	blastn	995	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
21351037	21351037	PRJNA976345_P_NODE_93577_length_194_cov_2.522013_g91969_i0	PRJNA976345	93577	194	2.522013	4.89270522	Marinitoga piezophila	149715	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|372100556\|gb\|CP003257.1\|	443254	g91969	i0	100	0.144329896907216	28	0	14	0	108	135	1230768	1230741	Marinitoga piezophila KA3, complete genome	blastn	28	52.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga piezophila
22625123	22625123	PRJNA976345_P_NODE_176258_length_157_cov_0.983607_g174650_i0	PRJNA976345	176258	157	0.983607	1.54426299	Thermus sp. PS18	2849039	Bacteria	Bacteria	99	1.64e-16	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g174650	i0	86.667	1.80891719745223	90	10	57	2	46	134	1911303	1911391	Thermus sp. PS18 chromosome, complete genome	blastn	284	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
25174083	25174083	PRJNA976345_P_NODE_163940_length_161_cov_1.333333_g162332_i0	PRJNA976345	163940	161	1.333333	2.14666613	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	243	7.39e-60	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g162332	i0	97.872	8.01863354037267	141	2	100	1	22	161	1915485	1915625	Thermus sp. NEB1569 chromosome, complete genome	blastn	1291	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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