metadata: contig_metadata: 8 rows where bioproject = "PRJNA395690" and tax

8 rows where bioproject = "PRJNA395690" and tax_phylum = "Tubulinea"

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
411844	411844	PRJNA395690_P_NODE_881_length_833_cov_4.489796_g764_i0	PRJNA395690	881	833	4.489796	37.40000068	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	1109	0	NTclustered	gi\|2651357777\|gb\|PP174294.1\|	1078836	g764	i0	90.67	38.5042016806723	836	75	100	1	1	833	3075	2240	Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	32074	1109	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
1686647	1686647	PRJNA395690_P_NODE_5622_length_338_cov_2.159170_g5472_i0	PRJNA395690	5622	338	2.15917	7.2979946	Nebela tincta	318538	Tubulinea	other_Eukaryota	130	1.43e-25	NTclustered	gi\|410369741\|gb\|JX682597.1\|	318538	g5472	i0	75.655	27.7810650887574	267	61	79	4	1	267	61	323	Nebela tincta isolate tin62 cytochrome oxidase subunit 1-like (COI) gene, partial sequence; mitochondrial	blastn	9390	130	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Hyalospheniidae	Nebela	Nebela tincta
7456824	7456824	PRJNA395690_P_NODE_10066_length_256_cov_1.850242_g9914_i0	PRJNA395690	10066	256	1.850242	4.73661952	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	457	4.22e-124	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g9914	i0	98.828	29.8671875	256	3	100	0	1	256	922	1177	Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	7646	457	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
14440310	14440310	PRJNA395690_P_NODE_12172_length_233_cov_9.097826_g12020_i0	PRJNA395690	12172	233	9.097826	21.19793458	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	331	2.39e-86	NTclustered	gi\|2651357777\|gb\|PP174294.1\|	1078836	g12020	i0	92.275	1	233	18	100	0	1	233	4307	4075	Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	233	331	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
15106753	15106753	PRJNA395690_P_NODE_31652_length_164_cov_1.895652_g31500_i0	PRJNA395690	31652	164	1.895652	3.10886928	Arcella hemisphaerica	497998	Tubulinea	other_Eukaryota	92.4	1.3e-21	NR	AFX73089.1	497998	g31500	i0	74.5	8.61585365853658	51	13	93.3	0	162	10	46	96	AFX73089.1 elongation factor 2 alpha, partial [Arcella hemisphaerica]	diamond	1413	92.4	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica
16988950	16988950	PRJNA395690_P_NODE_14514_length_213_cov_47.670732_g14362_i0	PRJNA395690	14514	213	47.670732	101.53865916	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	270	4.75e-68	NTclustered	gi\|2651357777\|gb\|PP174294.1\|	1078836	g14362	i0	97.468	73.2488262910798	158	4	74	0	46	203	1675	1832	Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	15602	270	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
18263240	18263240	PRJNA395690_P_NODE_21235_length_184_cov_1.096296_g21083_i0	PRJNA395690	21235	184	1.096296	2.01718464	Cryptodifflugia oviformis	1165352	Tubulinea	other_Eukaryota	283	5.11e-72	NTclustered	gi\|2517949732\|gb\|OR125031.1\|	1165352	g21083	i0	94.565	31.0217391304348	184	9	100	1	1	184	884	702	Cryptodifflugia oviformis isolate strain_6 small subunit ribosomal RNA gene, partial sequence	blastn	5708	283	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia oviformis
23363858	23363858	PRJNA395690_P_NODE_35099_length_162_cov_0.902655_g34947_i0	PRJNA395690	35099	162	0.902655	1.4623011	Ptolemeba bulliensis	1525729	Tubulinea	other_Eukaryota	76.8	8e-10	NTclustered	gi\|1255287463\|dbj\|LC272071.1\|	1525729	g34947	i0	86.957	0.425925925925926	69	7	43	1	42	110	965	899	Ptolemeba bulliensis gene for 18S ribosomal RNA, partial sequence, strain: ATCC 50249	blastn	69	76.8	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba bulliensis

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