contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax_phylum = "Rotifera"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3364412 | 3364412 | PRJNA812715_P_NODE_48823_length_389_cov_0.974684_g47026_i0 | PRJNA812715 | 48823 | 389 | 0.974684 | 3.79152076 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 549 | 1.0799999999999997e-151 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g47026 | i0 | 92.288 | 7.02827763496144 | 389 | 27 | 99 | 3 | 2 | 389 | 2391 | 2005 | Philodina citrina complete mitochondrial genome | blastn | 2734 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 4640492 | 4640492 | PRJNA812715_P_NODE_112304_length_246_cov_0.890173_g110503_i0 | PRJNA812715 | 112304 | 246 | 0.890173 | 2.18982558 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 422 | 1.47e-113 | NTclustered | gi|62362189|gb|AY942834.1| | 249248 | g110503 | i0 | 97.561 | 1 | 246 | 6 | 100 | 0 | 1 | 246 | 54 | 299 | Adineta ricciae amphiHMG1/2-like protein mRNA, partial cds | blastn | 246 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 12292911 | 12292911 | PRJNA812715_P_NODE_54030_length_363_cov_1.062069_g52231_i0 | PRJNA812715 | 54030 | 363 | 1.062069 | 3.85531047 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 579 | 1.2799999999999996e-160 | NTclustered | gi|187233665|gb|EU643499.1| | 104782 | g52231 | i0 | 95.568 | 0.994490358126722 | 361 | 16 | 99 | 0 | 1 | 361 | 391 | 31 | Adineta vaga ribosomal protein L26 mRNA, partial cds | blastn | 361 | 579 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 16115258 | 16115258 | PRJNA812715_P_NODE_26393_length_611_cov_2.671004_g24663_i0 | PRJNA812715 | 26393 | 611 | 2.671004 | 16.31983444 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 669 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g24663 | i0 | 86.688 | 31.8330605564648 | 616 | 67 | 99 | 14 | 3 | 611 | 2393 | 1786 | Philodina citrina complete mitochondrial genome | blastn | 19450 | 669 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 16527823 | 16527823 | PRJNA812715_P_NODE_58773_length_343_cov_1.711111_g56974_i0 | PRJNA812715 | 58773 | 343 | 1.711111 | 5.86911073 | Ploima | 84394 | Rotifera | other_Eukaryota | 307 | 6.270000000000001e-79 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g56974 | i0 | 83.235 | 86.7172011661808 | 340 | 52 | 99 | 5 | 1 | 338 | 12345 | 12009 | Proales similis mitochondrion, complete genome | blastn | 29744 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 18663333 | 18663333 | PRJNA812715_P_NODE_108215_length_248_cov_0.880000_g106414_i0 | PRJNA812715 | 108215 | 248 | 0.88 | 2.1824 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 453 | 5.2600000000000005e-123 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g106414 | i0 | 99.597 | 4.10483870967742 | 248 | 1 | 100 | 0 | 1 | 248 | 10361 | 10114 | 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 | 1018 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 19940425 | 19940425 | PRJNA812715_P_NODE_56576_length_352_cov_1.103943_g54777_i0 | PRJNA812715 | 56576 | 352 | 1.103943 | 3.88587936 | Monostyla sp. MPN-2013 | 1443992 | Rotifera | other_Eukaryota | 259 | 1.83e-64 | NTclustered | gi|572455655|gb|KF159018.1| | 1443992 | g54777 | i0 | 81.424 | 36.2272727272727 | 323 | 54 | 91 | 6 | 31 | 350 | 389 | 70 | Monostyla sp. MPN-2013 methionine adenosyltransferase mRNA, partial cds | blastn | 12752 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Monostyla | Monostyla sp. MPN-2013 | |
| 22489644 | 22489644 | PRJNA812715_P_NODE_27878_length_586_cov_1.491228_g26128_i0 | PRJNA812715 | 27878 | 586 | 1.491228 | 8.73859608 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 237 | 1.49e-57 | NTclustered | gi|1800329609|gb|MN417951.1| | 104777 | g26128 | i0 | 77.59 | 5.99488054607508 | 415 | 77 | 70 | 14 | 6 | 413 | 10240 | 9835 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 3513 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;