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

12 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax_phylum = "Acidobacteriota"

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
1726905	1726905	PRJNA492280_P_NODE_842_length_479_cov_5.266968_g747_i0	PRJNA492280	842	479	5.266968	25.22877672	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	385	4.0499999999999996e-102	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g747	i0	97.368	118.327766179541	228	3	63	3	87	312	111	337	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	56679	385	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6829583	6829583	PRJNA492280_P_NODE_28186_length_157_cov_4.091667_g28079_i0	PRJNA492280	28186	157	4.091667	6.42391719	Luteitalea pratensis	1855912	Bacteria	Bacteria	265	1.53e-66	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g28079	i0	98.658	48.2356687898089	149	2	95	0	2	150	654456	654604	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	7573	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
11302213	11302213	PRJNA492280_P_NODE_33329_length_150_cov_4.141593_g33222_i0	PRJNA492280	33329	150	4.141593	6.2123895	Acidobacteriaceae	204434	Bacteria	Bacteria	111	1.99e-20	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g33222	i0	80.864	5.67333333333333	162	14	97	9	5	149	3268278	3268117	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	851	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
11930518	11930518	PRJNA492280_P_NODE_1570_length_354_cov_6.075710_g1464_i0	PRJNA492280	1570	354	6.07571	21.5080134	Luteitalea pratensis	1855912	Bacteria	Bacteria	300	1.08e-76	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g1464	i0	96.196	74.9915254237288	184	6	52	1	169	352	653441	653259	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	26547	300	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
11930669	11930669	PRJNA492280_P_NODE_30830_length_151_cov_3.789474_g30723_i0	PRJNA492280	30830	151	3.789474	5.72210574	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	159	7.059999999999998e-35	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g30723	i0	87.857	124.913907284768	140	12	90	3	2	137	1820931	1821069	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	18862	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
14480564	14480564	PRJNA492280_P_NODE_2232_length_309_cov_7.702206_g2125_i0	PRJNA492280	2232	309	7.702206	23.79981654	Luteitalea pratensis	1855912	Bacteria	Bacteria	292	1.5599999999999999e-74	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g2125	i0	99.379	53.0355987055016	161	1	94	0	4	164	655594	655434	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	16388	292	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
17029212	17029212	PRJNA492280_P_NODE_1694_length_343_cov_12.287582_g1588_i0	PRJNA492280	1694	343	12.287582	42.14640626	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	8.34e-58	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g1588	i0	98.507	103.020408163265	134	2	39	0	1	134	134	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	35336	237	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18950368	18950368	PRJNA492280_P_NODE_15615_length_164_cov_4.370079_g15508_i0	PRJNA492280	15615	164	4.370079	7.16692956	Luteitalea	2004797	Bacteria	Bacteria	135	1.32e-27	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g15508	i0	98.701	50.0365853658537	77	0	89	1	1	76	654078	654154	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	8206	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
20225504	20225504	PRJNA492280_P_NODE_34796_length_150_cov_2.566372_g34689_i0	PRJNA492280	34796	150	2.566372	3.849558	Acidobacteriaceae	204434	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g34689	i0	100	121.913333333333	147	0	98	0	1	147	3871038	3871184	Terriglobus saanensis SP1PR4, complete genome	blastn	18287	272	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
22128548	22128548	PRJNA492280_P_NODE_8418_length_183_cov_3.178082_g8311_i0	PRJNA492280	8418	183	3.178082	5.81589006	Terriglobus albidus	1592106	Bacteria	Bacteria	237	4.01e-58	NTclustered	gi\|1724546188\|gb\|CP042806.1\|	1592106	g8311	i0	90.556	20.431693989071	180	16	98	1	1	180	6047261	6047439	Terriglobus albidus strain ORNL chromosome, complete genome	blastn	3739	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus albidus
22776168	22776168	PRJNA492280_P_NODE_8658_length_181_cov_3.180556_g8551_i0	PRJNA492280	8658	181	3.180556	5.75680636	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	159	8.809999999999998e-35	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8551	i0	97.826	61.6077348066298	92	2	85	0	1	92	3299140	3299231	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	11151	159	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23404176	23404176	PRJNA492280_P_NODE_15999_length_164_cov_4.228346_g15892_i0	PRJNA492280	15999	164	4.228346	6.93448744	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|2874253940\|emb\|OY970265.1\|	171953	g15892	i0	86.875	5.74390243902439	160	10	98	1	2	161	48587	48439	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1	blastn	942	172	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium

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