metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Thermomicrobiota"

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
2395236	2395236	PRJNA550047_P_NODE_10482_length_587_cov_21.050584_g8690_i0	PRJNA550047	10482	587	21.050584	123.56692808	Sphaerobacter	2056	Bacteria	Bacteria	401	4.999999999999999e-107	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g8690	i0	80.102	182.182282793867	588	77	97	24	14	583	1113	548	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	106941	401	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
2395378	2395378	PRJNA550047_P_NODE_12922_length_552_cov_8.096033_g11082_i0	PRJNA550047	12922	552	8.096033	44.69010216	Sphaerobacter	2056	Bacteria	Bacteria	462	2.1199999999999995e-125	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g11082	i0	82.111	244.909420289855	559	83	99	15	1	550	1223	673	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	135190	462	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
2397855	2397855	PRJNA550047_P_NODE_7902_length_656_cov_21.406518_g6185_i0	PRJNA550047	7902	656	21.406518	140.42675808	Sphaerobacter	2056	Bacteria	Bacteria	429	2.58e-115	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g6185	i0	78.932	121.149390243902	674	110	99	21	1	650	707	42	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	79474	429	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
5620627	5620627	PRJNA550047_P_NODE_466245_length_242_cov_1.828402_g464272_i0	PRJNA550047	466245	242	1.828402	4.42473284	Thermomicrobium roseum	500	Bacteria	Bacteria	108	4.59e-19	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g464272	i0	75.641	24.7355371900826	234	48	95	9	1	229	332360	332589	Thermomicrobium roseum DSM 5159, complete genome	blastn	5986	108	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
8773977	8773977	PRJNA550047_P_NODE_3327_length_1053_cov_16.419388_g1031_i1	PRJNA550047	3327	1053	16.419388	172.89615564	Sphaerobacter	2056	Bacteria	Bacteria	649	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g1031	i1	80.543	102.854700854701	884	138	83	20	8	883	670	1527	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	108306	649	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
11324446	11324446	PRJNA550047_P_NODE_399189_length_265_cov_9.296875_g397217_i0	PRJNA550047	399189	265	9.296875	24.63671875	Thermomicrobium	499	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g397217	i0	77.941	21.5094339622642	204	29	74	16	69	263	426	230	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	5700	113	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
16424000	16424000	PRJNA550047_P_NODE_372853_length_275_cov_33.267327_g370881_i0	PRJNA550047	372853	275	33.267327	91.48514925	Thermomicrobium	499	Bacteria	Bacteria	180	1.11e-40	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g370881	i0	79.078	150.407272727273	282	44	100	12	1	275	1136	863	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	41362	180	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
23470835	23470835	PRJNA550047_P_NODE_60919_length_345_cov_14.658088_g58959_i0	PRJNA550047	60919	345	14.658088	50.5704036	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	137	8.76e-28	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g58959	i0	90.385	2.97971014492754	104	10	43	0	242	345	1711105	1711208	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	1028	137	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25346725	25346725	PRJNA550047_P_NODE_199320_length_343_cov_7.659259_g197359_i0	PRJNA550047	199320	343	7.659259	26.27125837	Sphaerobacter	2056	Bacteria	Bacteria	359	1.7099999999999998e-94	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g197359	i0	85.797	330.189504373178	345	41	99	7	3	343	881	1221	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	113255	359	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus

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