contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax_kingdom = "Loebvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57386 | 57386 | PRJEB39643_P_NODE_124261_length_250_cov_1.740113_g124068_i0 | PRJEB39643 | 124261 | 250 | 1.740113 | 4.3502825 | Inoviridae sp. | 2219103 | Viruses | Viruses | 401 | 1.9499999999999994e-107 | NTclustered | gi|2057182301|tpg|BK059046.1| | 2219103 | g124068 | i0 | 95.6 | 26.06 | 250 | 11 | 100 | 0 | 1 | 250 | 9749 | 9500 | MAG TPA_asm: Inoviridae sp. isolate ctMrk11, partial genome | blastn | 6515 | 401 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 57558 | 57558 | PRJEB39643_P_NODE_141981_length_244_cov_1.801170_g141788_i0 | PRJEB39643 | 141981 | 244 | 1.80117 | 4.3948548 | Inoviridae sp. | 2219103 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2054640328|tpg|BK051800.1| | 2219103 | g141788 | i0 | 100 | 25.1311475409836 | 244 | 0 | 100 | 0 | 1 | 244 | 14733 | 14490 | MAG TPA_asm: Inoviridae sp. isolate ctJG56, partial genome | blastn | 6132 | 451 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1331687 | 1331687 | PRJEB39643_P_NODE_127122_length_249_cov_1.750000_g126929_i0 | PRJEB39643 | 127122 | 249 | 1.75 | 4.3575 | Inoviridae sp. | 2219103 | Viruses | Viruses | 444 | 3.18e-120 | NTclustered | gi|2057880594|tpg|BK050833.1| | 2219103 | g126929 | i0 | 98.795 | 99.995983935743 | 249 | 3 | 100 | 0 | 1 | 249 | 13969 | 14217 | MAG TPA_asm: Inoviridae sp. isolate ctYis4, partial genome | blastn | 24899 | 444 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1332366 | 1332366 | PRJEB39643_P_NODE_43522_length_290_cov_1.419355_g43329_i0 | PRJEB39643 | 43522 | 290 | 1.419355 | 4.1161295 | Inoviridae sp. | 2219103 | Viruses | Viruses | 462 | 1.05e-125 | NTclustered | gi|2056943374|tpg|BK022534.1| | 2219103 | g43329 | i0 | 96.751 | 35.348275862069 | 277 | 9 | 96 | 0 | 14 | 290 | 3527 | 3251 | MAG TPA_asm: Inoviridae sp. isolate ctNUz14, partial genome | blastn | 10251 | 462 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 3884063 | 3884063 | PRJEB39643_P_NODE_33964_length_319_cov_1.878049_g33771_i0 | PRJEB39643 | 33964 | 319 | 1.878049 | 5.99097631 | Inoviridae sp. ct6Op23 | 2826757 | Viruses | Viruses | 545 | 1.13e-150 | NTclustered | gi|2051143877|tpg|BK015782.1| | 2826757 | g33771 | i0 | 97.492 | 13.0156739811912 | 319 | 8 | 100 | 0 | 1 | 319 | 8272 | 8590 | MAG TPA_asm: Inoviridae sp. ct6Op23, partial genome | blastn | 4152 | 545 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. ct6Op23 | |||
| 5160034 | 5160034 | PRJEB39643_P_NODE_158625_length_214_cov_17.503546_g158431_i0 | PRJEB39643 | 158625 | 214 | 17.503546 | 37.45758844 | Inovirus M13 | 1977402 | Viruses | Viruses | 99 | 2.39e-16 | NTclustered | gi|2071736794|gb|MW984356.1| | 1977402 | g158431 | i0 | 96.61 | 16.107476635514 | 59 | 2 | 46 | 0 | 154 | 212 | 80 | 138 | Escherichia virus M13 clone MAP 9 PIII coat protein gene, partial cds | blastn | 3447 | 99 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inovirus | Inovirus M13 | ||
| 8985217 | 8985217 | PRJEB39643_P_NODE_47608_length_287_cov_2.158879_g47415_i0 | PRJEB39643 | 47608 | 287 | 2.158879 | 6.19598273 | Inoviridae sp. ct6Op23 | 2826757 | Viruses | Viruses | 479 | 1.0299999999999996e-130 | NTclustered | gi|2051143877|tpg|BK015782.1| | 2826757 | g47415 | i0 | 96.099 | 23.9128919860627 | 282 | 11 | 98 | 0 | 6 | 287 | 341 | 622 | MAG TPA_asm: Inoviridae sp. ct6Op23, partial genome | blastn | 6863 | 479 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. ct6Op23 | |||
| 15360533 | 15360533 | PRJEB39643_P_NODE_71593_length_275_cov_1.524752_g71400_i0 | PRJEB39643 | 71593 | 275 | 1.524752 | 4.193068 | Inoviridae sp. | 2219103 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|2057175348|tpg|BK058900.1| | 2219103 | g71400 | i0 | 100 | 16.0727272727273 | 275 | 0 | 100 | 0 | 1 | 275 | 6109 | 6383 | MAG TPA_asm: Inoviridae sp. isolate ct5N49, partial genome | blastn | 4420 | 508 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23009515 | 23009515 | PRJEB39643_P_NODE_137879_length_245_cov_1.790698_g137686_i0 | PRJEB39643 | 137879 | 245 | 1.790698 | 4.3872101 | Inoviridae sp. | 2219103 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|2056839431|tpg|BK044096.1| | 2219103 | g137686 | i0 | 99.184 | 26.0285714285714 | 245 | 2 | 100 | 0 | 1 | 245 | 8361 | 8117 | MAG TPA_asm: Inoviridae sp. isolate ctx2K3, partial genome | blastn | 6377 | 442 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. |
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);;