metadata: contig_metadata: 15 rows where bioproject = "PRJEB11523" and tax

15 rows where bioproject = "PRJEB11523" and tax_phylum = "Bacillariophyta"

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_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
13739	13739	PRJEB11523_P_NODE_5201_length_205_cov_1.211538_g5123_i0	PRJEB11523	5201	205	1.211538	2.4836529	Nitzschia sp. pyKryTriq1	3034176	SAR_Eukaryotes	SAR_Eukaryotes	292	9.69e-75	NTclustered	gi\|2524387093\|emb\|OY101132.1\|	3034176	g5123	i0	95.604	93.5658536585366	182	8	89	0	1	182	33637	33818	Nitzschia sp. pyKryTriq1 genome assembly, organelle: mitochondrion	blastn	19181	292	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia sp. pyKryTriq1
982486	982486	PRJEB11523_P_NODE_4541_length_221_cov_24.360465_g4463_i0	PRJEB11523	4541	221	24.360465	53.83662765	Nitzschia	2857	SAR_Eukaryotes	SAR_Eukaryotes	363	7.97e-96	NTclustered	gi\|1891520243\|gb\|MN696747.1\|	185983	g4463	i0	99.01	91.4027149321267	202	2	91	0	20	221	114	315	Nitzschia cf. pusilla culture TCC:586 large subunit ribosomal RNA gene, partial sequence	blastn	20200	363	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia cf. pusilla
8940732	8940732	PRJEB11523_P_NODE_4308_length_229_cov_7.683333_g4230_i0	PRJEB11523	4308	229	7.683333	17.59483257	Lineaperpetua lacustris	2923095	SAR_Eukaryotes	SAR_Eukaryotes	315	2.36e-81	NTclustered	gi\|2728413486\|gb\|OR666654.1\|	2923095	g4230	i0	94.608	174.681222707424	204	10	89	1	26	229	68928	69130	Thalassiosira lacustris strain SXU-149 chloroplast, complete genome	blastn	40002	315	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Lineaperpetua	Lineaperpetua lacustris
10216541	10216541	PRJEB11523_P_NODE_6329_length_183_cov_5.470149_g6251_i0	PRJEB11523	6329	183	5.470149	10.01037267	Encyonema minutum	431330	SAR_Eukaryotes	SAR_Eukaryotes	322	1.08e-83	NTclustered	gi\|168145881\|emb\|AM710515.1\|	431330	g6251	i0	100	98.2131147540984	174	0	95	0	10	183	128	301	Encyonema minutum partial 28S rRNA gene, strain AT-137.13	blastn	17973	322	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Cymbellaceae	Encyonema	Encyonema minutum
11491716	11491716	PRJEB11523_P_NODE_2850_length_301_cov_2.369048_g2772_i0	PRJEB11523	2850	301	2.369048	7.13083448	Ulnaria acus	1436140	SAR_Eukaryotes	SAR_Eukaryotes	359	1.4699999999999998e-94	NTclustered	gi\|283795033\|ref\|NC_013710.1\|	1436140	g2772	i0	89.492	1.0797342192691	295	15	95	12	17	301	33469	33181	Synedra acus mitochondrion, complete genome	blastn	325	359	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Licmophorales	Ulnariaceae	Ulnaria	Ulnaria acus
17560403	17560403	PRJEB11523_P_NODE_5274_length_203_cov_3.753247_g5196_i0	PRJEB11523	5274	203	3.753247	7.61909141	Fragilariophyceae	33853	SAR_Eukaryotes	SAR_Eukaryotes	342	9.369999999999999e-90	NTclustered	gi\|2579686273\|ref\|NC_082433.1\|	426669	g5196	i0	99.468	184.266009852217	188	1	93	0	1	188	66141	65954	Ulnaria ulna chloroplast, complete genome	blastn	37406	342	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Licmophorales	Ulnariaceae	Ulnaria	Ulnaria ulna
20414412	20414412	PRJEB11523_P_NODE_8937_length_156_cov_2.523364_g8859_i0	PRJEB11523	8937	156	2.523364	3.93644784	Sundstroemia setigera	3005	SAR_Eukaryotes	SAR_Eukaryotes	163	5.69e-36	NTclustered	gi\|2172620428\|ref\|NC_059919.1\|	3005	g8859	i0	89.231	82.4551282051282	130	14	83	0	27	156	21901	21772	Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome	blastn	12863	163	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Sundstroemia	Sundstroemia setigera
22659525	22659525	PRJEB11523_P_NODE_5598_length_196_cov_14.292517_g5520_i0	PRJEB11523	5598	196	14.292517	28.01333332	root	1	Root_unresolved	Root_unresolved	254	4.33e-63	NTclustered	gi\|1803023461\|gb\|MN937452.1\|	2850	g5520	i0	98.611	92.6530612244898	144	0	72	1	23	164	69260	69403	Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome	blastn	18160	255	0.996078431372549	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27948793	27948793	PRJEB11523_P_NODE_3265_length_275_cov_2.340708_g3187_i0	PRJEB11523	3265	275	2.340708	6.436947	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	122	1.25e-30	NR	CAB9531516.1	568900	g3187	i0	61.9	1.85454545454545	84	32	91.6	0	1	252	148	231	CAB9531516.1 osmC-like protein [Seminavis robusta]	diamond	510	122	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
28037491	28037491	PRJEB11523_P_NODE_3725_length_251_cov_2.801980_g3647_i0	PRJEB11523	3725	251	2.80198	7.0329698	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	142	1.54e-39	NR	KAG7356896.1	303405	g3647	i0	89.9	4.72111553784861	79	8	94.4	0	14	250	230	308	KAG7356896.1 mitochondrial carrier protein [Nitzschia inconspicua]	diamond	1185	142	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28043493	28043493	PRJEB11523_P_NODE_1785_length_416_cov_2.275204_g1707_i0	PRJEB11523	1785	416	2.275204	9.46484864	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	46.6	9.11e-4	NR	EJK58442.1	159749	g1707	i0	64.9	0.266826923076923	37	13	26.7	0	273	383	24	60	EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica]	diamond	111	46.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
28706657	28706657	PRJEB11523_P_NODE_5807_length_192_cov_2.650350_g5729_i0	PRJEB11523	5807	192	2.65035	5.088672	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	65.5	5.84e-11	NR	KAG7338838.1	303405	g5729	i0	88.2	1.65625	34	4	53.1	0	160	59	184	217	KAG7338838.1 50S ribosomal protein L10 [Nitzschia inconspicua]	diamond	318	65.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
31581499	31581499	PRJEB11523_P_NODE_3256_length_275_cov_11.933628_g3178_i0	PRJEB11523	3256	275	11.933628	32.817477	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	87.4	6.59e-19	NR	KAL3942254.1	3061772	g3178	i0	57.9	1.64727272727273	76	26	76.4	2	24	233	9	84	KAL3942254.1 MAG: hypothetical protein SGBAC_003524 [Bacillariaceae sp.]	diamond	453	87.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31897640	31897640	PRJEB11523_P_NODE_6217_length_185_cov_2.661765_g6139_i0	PRJEB11523	6217	185	2.661765	4.92426525	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.97e-4	NR	CAB9514703.1	568900	g6139	i0	74.1	0.437837837837838	27	7	43.8	0	6	86	1271	1297	CAB9514703.1 Coatomer subunit alpha [Seminavis robusta]	diamond	81	47.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32119268	32119268	PRJEB11523_P_NODE_1438_length_477_cov_8.649533_g1360_i0	PRJEB11523	1438	477	8.649533	41.25827241	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	293	2.2999999999999998e-89	NR	KAL3765181.1	259834	g1360	i0	95.9	1.82389937106918	145	6	91.2	0	22	456	758	902	KAL3765181.1 hypothetical protein ACHAWU_010372 [Discostella pseudostelligera]	diamond	870	293	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera

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