metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
2161287	2161287	PRJNA906294_P_NODE_130362_length_343_cov_1.259259_g126246_i0	PRJNA906294	130362	343	1.259259	4.31925837	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	435	2.76e-117	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g126246	i0	89.504	71.8396501457726	343	36	100	0	1	343	229	571	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	24641	435	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
2163272	2163272	PRJNA906294_P_NODE_213522_length_247_cov_0.873563_g209406_i0	PRJNA906294	213522	247	0.873563	2.15770061	Adineta vaga	104782	Rotifera	other_Eukaryota	446	8.759999999999998e-121	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g209406	i0	99.19	4.8582995951417	247	2	100	0	1	247	10073	10319	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	1200	446	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
7266463	7266463	PRJNA906294_P_NODE_232786_length_236_cov_2.693252_g228670_i0	PRJNA906294	232786	236	2.693252	6.35607472	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	219	1.97e-52	NTclustered	gi\|62362199\|gb\|AY942839.1\|	317012	g228670	i0	86.911	3.89830508474576	191	25	81	0	4	194	248	58	Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds	blastn	920	219	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
9813837	9813837	PRJNA906294_P_NODE_126888_length_349_cov_1.945652_g122772_i0	PRJNA906294	126888	349	1.945652	6.79032548	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	464	3.5699999999999996e-126	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g122772	i0	90.778	93.4985673352435	347	32	99	0	1	347	640	986	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	32631	464	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
11090109	11090109	PRJNA906294_P_NODE_150889_length_310_cov_1.784810_g146773_i0	PRJNA906294	150889	310	1.78481	5.532911	Adineta vaga	104782	Rotifera	other_Eukaryota	326	1.55e-84	NTclustered	gi\|187233661\|gb\|EU643497.1\|	104782	g146773	i0	86.577	2.97741935483871	298	36	95	4	14	309	259	554	Adineta vaga putative ribosomal protein L7 mRNA, partial cds	blastn	923	326	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
11090855	11090855	PRJNA906294_P_NODE_181849_length_273_cov_2.170000_g177733_i0	PRJNA906294	181849	273	2.17	5.9241	Philodina citrina	468664	Rotifera	other_Eukaryota	355	1.7099999999999997e-93	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g177733	i0	90.146	62.5531135531136	274	25	100	2	1	273	1886	2158	Philodina citrina complete mitochondrial genome	blastn	17077	355	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
14915095	14915095	PRJNA906294_P_NODE_178932_length_276_cov_2.236453_g174816_i0	PRJNA906294	178932	276	2.236453	6.17261028	Adineta vaga	104782	Rotifera	other_Eukaryota	215	3.06e-51	NTclustered	gi\|189313924\|gb\|EU637018.1\|	104782	g174816	i0	89.08	5.14492753623188	174	17	95	2	103	275	5408	5580	Adineta vaga 7 transmembrane receptor 2, 7 transmembrane receptor 4, myosin alkali light chain, sodefrin precursor repeats A, sodefrin precursor repeats C, metal binding protein, tRNA methyltransferase, laminin-G, tetratricopeptide repeat containing protein, hsp82, hypothetical proteins, zinc carboxypeptidase, hypothetical protein, and saicars genes, complete cds; and hypothetical protein gene, partial cds	blastn	1420	215	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
14915634	14915634	PRJNA906294_P_NODE_201072_length_254_cov_1.580110_g196956_i0	PRJNA906294	201072	254	1.58011	4.0134794	Philodina citrina	468664	Rotifera	other_Eukaryota	213	1e-50	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g196956	i0	81.818	10.7047244094488	253	46	99	0	1	253	10234	9982	Philodina citrina complete mitochondrial genome	blastn	2719	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
16189936	16189936	PRJNA906294_P_NODE_178233_length_277_cov_1.490196_g174117_i0	PRJNA906294	178233	277	1.490196	4.12784292	Adineta vaga	104782	Rotifera	other_Eukaryota	215	3.07e-51	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g174117	i0	90.244	2.38628158844765	164	16	59	0	114	277	30098	30261	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	661	215	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
17465658	17465658	PRJNA906294_P_NODE_190594_length_265_cov_1.031250_g186478_i0	PRJNA906294	190594	265	1.03125	2.7328125	Philodina roseola	96448	Rotifera	other_Eukaryota	215	2.92e-51	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g186478	i0	86.598	34.3509433962264	194	26	73	0	72	265	26049	26242	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	9103	215	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
21287483	21287483	PRJNA906294_P_NODE_112597_length_380_cov_2.527687_g108482_i0	PRJNA906294	112597	380	2.527687	9.6052106	Adineta vaga	104782	Rotifera	other_Eukaryota	501	2.99e-137	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g108482	i0	92.113	0.934210526315789	355	28	93	0	1	355	355	1	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	355	501	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
22564079	22564079	PRJNA906294_P_NODE_176138_length_279_cov_2.145631_g172022_i0	PRJNA906294	176138	279	2.145631	5.98631049	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	268	2.3399999999999994e-67	NTclustered	gi\|62362203\|gb\|AY942841.1\|	317012	g172022	i0	84.286	1.00358422939068	280	38	99	5	1	277	390	114	Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds	blastn	280	268	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
22566889	22566889	PRJNA906294_P_NODE_86418_length_464_cov_2.150895_g82304_i0	PRJNA906294	86418	464	2.150895	9.9801528	Philodina citrina	468664	Rotifera	other_Eukaryota	477	6.269999999999998e-130	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g82304	i0	85.532	28.1206896551724	470	52	100	14	1	464	2206	1747	Philodina citrina complete mitochondrial genome	blastn	13048	477	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23838144	23838144	PRJNA906294_P_NODE_130519_length_343_cov_0.951852_g126403_i0	PRJNA906294	130519	343	0.951852	3.26485236	Adineta vaga	104782	Rotifera	other_Eukaryota	351	2.86e-92	NTclustered	gi\|402761787\|gb\|JX184025.1\|	104782	g126403	i0	85.886	36.2099125364431	333	44	97	3	13	343	512	181	Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	12420	351	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
25112031	25112031	PRJNA906294_P_NODE_131420_length_341_cov_1.317164_g127304_i0	PRJNA906294	131420	341	1.317164	4.49152924	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	425	1.6499999999999998e-114	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g127304	i0	89.381	80.7595307917889	339	35	99	1	1	339	1295	958	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	27539	425	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera

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