metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Rotifera"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1654713	1654713	PRJNA312899_P_NODE_64482_length_207_cov_1.227848_g64040_i0	PRJNA312899	64482	207	1.227848	2.54164536	Adineta vaga	104782	Rotifera	other_Eukaryota	377	2.63e-100	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g64040	i0	99.517	13.1980676328502	207	1	100	0	1	207	2401	2607	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	2732	377	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
4207709	4207709	PRJNA312899_P_NODE_99164_length_162_cov_0.902655_g98722_i0	PRJNA312899	99164	162	0.902655	1.4623011	Lecane bulla	96446	Rotifera	other_Eukaryota	300	4.36e-77	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g98722	i0	100	52.3950617283951	162	0	100	0	1	162	1657	1496	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	8488	300	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
7442427	7442427	PRJNA312899_P_NODE_35386_length_304_cov_57.203922_g34944_i0	PRJNA312899	35386	304	57.203922	173.89992288	Philodinidae	44580	Rotifera	other_Eukaryota	350	8.97e-92	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g34944	i0	87.829	4.92105263157895	304	30	99	7	4	304	2418	2119	Rotaria rotatoria mitochondrion, complete genome	blastn	1496	350	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
8032649	8032649	PRJNA312899_P_NODE_34867_length_307_cov_25.941860_g34425_i0	PRJNA312899	34867	307	25.94186	79.6415102	Philodina citrina	468664	Rotifera	other_Eukaryota	418	2.449999999999999e-112	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g34425	i0	93.031	4.40065146579805	287	18	93	2	3	288	2108	2393	Philodina citrina complete mitochondrial genome	blastn	1351	418	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
10584298	10584298	PRJNA312899_P_NODE_93869_length_164_cov_0.886957_g93427_i0	PRJNA312899	93869	164	0.886957	1.45460948	Adineta vaga	104782	Rotifera	other_Eukaryota	191	2.78e-44	NTclustered	gi\|187936040\|gb\|EU652315.1\|	104782	g93427	i0	89.241	0.963414634146341	158	9	95	3	9	164	18038	17887	Adineta vaga speckle-type POZ protein gene, partial cds; and adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, arginine vasopressin receptor, filament protein, and nucleolar complex associated-like protein genes, complete cds	blastn	158	191	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13133303	13133303	PRJNA312899_P_NODE_41751_length_275_cov_3.566372_g41309_i0	PRJNA312899	41751	275	3.566372	9.807523	Adineta vaga	104782	Rotifera	other_Eukaryota	128	4.08e-25	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g41309	i0	94.048	0.305454545454545	84	5	31	0	162	245	447	364	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	84	128	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
14407911	14407911	PRJNA312899_P_NODE_13632_length_511_cov_19.303030_g13201_i0	PRJNA312899	13632	511	19.30303	98.6384833	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	628	1.8199999999999998e-175	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g13201	i0	89.105	30.9765166340509	514	45	99	11	4	511	2418	1910	Rotaria rotatoria mitochondrion, complete genome	blastn	15829	628	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
18231121	18231121	PRJNA312899_P_NODE_34875_length_307_cov_20.813953_g34433_i0	PRJNA312899	34875	307	20.813953	63.89883571	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	368	2.5e-97	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g34433	i0	88.525	6.09120521172638	305	33	99	2	1	304	2120	2423	Rotaria rotatoria mitochondrion, complete genome	blastn	1870	368	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
20190818	20190818	PRJNA312899_P_NODE_55736_length_229_cov_3.400000_g55294_i0	PRJNA312899	55736	229	3.4	7.786	Eurotatoria	2816136	Rotifera	other_Eukaryota	424	3.76e-114	NTclustered	gi\|1399047\|gb\|U41281.1\|PAU41281	44582	g55294	i0	100	100.078602620087	229	0	100	0	1	229	197	425	Philodina acuticornis 18S rRNA gene	blastn	22918	424	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina acuticornis
25290470	25290470	PRJNA312899_P_NODE_12180_length_542_cov_10.732252_g11753_i0	PRJNA312899	12180	542	10.732252	58.16880584	Adineta	104781	Rotifera	other_Eukaryota	963	0	NTclustered	gi\|1005055512\|gb\|KU860655.1\|	1813164	g11753	i0	98.887	44.7509225092251	539	6	99	0	4	542	1995	1457	Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence	blastn	24255	963	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. A JFF-2016

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